SUPPORT / SAMPLES & SAS NOTES
 

Support

Problem Note 44935: A "File does not exist" error might be issued when trying to read a transport file with the XPORT LIBNAME engine

DetailsAboutRate It
A transport file that can be read using the SAS Viewer might produce error messages like the following when you are trying to convert the file to a SAS data set using PROC COPY with the XPORT LIBNAME engine:
NOTE: Input library TEST is sequential. NOTE: Copying TEST.MYSAS to WORK.MYSAS (memtype=DATA). ERROR: File TEST.MYSAS does not exist. ERROR: File WORK.MYSAS has not been saved because copy could not be completed. NOTE: Statements not processed because of errors noted above. NOTE: PROCEDURE COPY used (Total process time): real time 0.40 seconds cpu time 0.06 seconds NOTE: The SAS System stopped processing this step because of errors.

These errors are most likely to occur when the transport file contains a table with the name in mixed case.

To circumvent the problem, do one of the following:

  1. If you do not have many tables, you can edit the files manually and change the table names to upper case.
  2. You can programmatically modify the table name. The sample program below reads in the file one byte at a time to find the area of the file (199x...207x hexadecimal area) that contains the table name, and changes it to upper case.
    data _null_; infile 'c:\trans.xpt' recfm=f lrecl=1; file 'c:\trans.xpt' recfm=f lrecl=1; input x $char1.; if 199x <= _n_ < 207x then x=upcase(x); put x $char1.; run;


Operating System and Release Information

Product FamilyProductSystemSAS Release
ReportedFixed*
SAS SystemBase SASMicrosoft Windows Server 2008 for x649.3 TS1M2
Microsoft Windows XP Professional9.3 TS1M2
Windows 7 Enterprise 32 bit9.3 TS1M2
Windows 7 Enterprise x649.3 TS1M2
Windows 7 Home Premium 32 bit9.3 TS1M2
Windows 7 Home Premium x649.3 TS1M2
Windows 7 Professional 32 bit9.3 TS1M2
Windows 7 Professional x649.3 TS1M2
Windows 7 Ultimate 32 bit9.3 TS1M2
Microsoft Windows Server 20089.3 TS1M2
Microsoft Windows Server 2003 for x649.3 TS1M2
Microsoft Windows Server 2003 Standard Edition9.3 TS1M2
OS/2
Microsoft Windows 95/98
Microsoft Windows 2000 Advanced Server
Microsoft Windows 2000 Datacenter Server
Microsoft Windows 2000 Server
Microsoft Windows 2000 Professional
Microsoft Windows NT Workstation
Microsoft Windows Server 2003 Datacenter Edition9.3 TS1M2
Microsoft Windows Server 2003 Enterprise Edition9.3 TS1M2
Microsoft® Windows® for x649.3 TS1M2
Microsoft Windows XP 64-bit Edition9.3 TS1M2
Microsoft Windows Server 2003 Enterprise 64-bit Edition9.3 TS1M2
Microsoft Windows Server 2003 Datacenter 64-bit Edition9.3 TS1M2
Microsoft® Windows® for 64-Bit Itanium-based Systems9.3 TS1M2
Z649.3 TS1M2
z/OS9.3 TS1M2
OpenVMS VAX9.3 TS1M2
Windows 7 Ultimate x649.3 TS1M2
Windows Millennium Edition (Me)
Windows Vista9.3 TS1M2
Windows Vista for x649.3 TS1M2
64-bit Enabled AIX9.3 TS1M2
64-bit Enabled HP-UX9.3 TS1M2
64-bit Enabled Solaris9.3 TS1M2
ABI+ for Intel Architecture9.3 TS1M2
AIX9.3 TS1M2
HP-UX9.3 TS1M2
HP-UX IPF9.3 TS1M2
IRIX9.3 TS1M2
Linux9.3 TS1M2
Linux for x649.3 TS1M2
Linux on Itanium9.3 TS1M2
OpenVMS Alpha9.3 TS1M2
OpenVMS on HP Integrity9.3 TS1M2
Solaris9.3 TS1M2
Solaris for x649.3 TS1M2
Tru64 UNIX9.3 TS1M2
* For software releases that are not yet generally available, the Fixed Release is the software release in which the problem is planned to be fixed.